SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001425s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533796 LIMIT 1 [ RunTime:0.000849s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533796 [ RunTime:0.003052s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (195719,920935,834910,170515,426654,957768,877620,980685,512137,960012,316844,625697,489914,688982,869369,509068,197795,112050,968379,363161,466777,767209,192058,334147,802610,1023200,680548,91072,453176,441084,36683,290857,1024623,656191,992055,881202,205349,769751,653235,84295,707637,434299,409209,916086,802377,991062,52005,764755,182477,1021844,227721,866953,755974,535308,642940,615548,160835,701475,165368,445412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533796 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533796 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]