SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001723s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504567 LIMIT 1 [ RunTime:0.001260s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504567 [ RunTime:0.004261s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (691319,255289,887901,926213,392860,432599,339932,1015144,810811,908813,926682,538279,1026905,73596,242535,128368,390070,691480,302486,367545,790528,899216,5654,748413,154232,505863,1017616,259199,1042062,341296,387281,532690,729358,681852,556899,670216,431678,558513,197393,759745,586472,970039,356014,1004742,918182,608942,777535,947762,851811,984658,208085,443690,565183,357119,349258,1030582,659938,962026,168636,944484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504567 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504567 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000775s ]