SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472911 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472911 [ RunTime:0.002701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31943,954145,131408,513295,583136,1036457,550509,486022,105045,148391,557481,437390,70984,915873,809110,126693,710435,89860,89368,761863,1002872,910959,631769,121765,463682,904474,637163,410159,884630,715750,494027,755313,501562,175055,647464,580836,439108,752556,159244,667159,535190,517324,527097,337052,367613,960949,223321,824927,289453,203937,781765,403380,917966,967175,502947,690493,382618,378304,717039,230991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]