SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012009 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012009 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137844,1031147,377998,198562,526832,917807,954423,724918,871539,446940,186551,317436,567691,528569,897515,443943,795412,428273,788574,498621,923875,1027914,935849,913430,655817,719059,790605,605541,671967,787046,141037,774196,580476,111430,786067,920782,540955,648843,314035,957180,375576,539669,870809,90041,174701,708059,661397,915386,263202,258862,373641,947880,261556,960517,326397,716658,256285,583456,336081,122133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]