SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001626s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504633 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504633 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384447,1018329,956343,982833,360895,260742,1041684,827863,107615,696426,822676,738661,598394,698380,341321,765415,99549,539207,801307,162133,433585,7622,401276,370829,132223,915940,437895,312706,711382,345054,149020,710703,862463,303153,155249,487647,725504,23611,874861,609509,426067,800499,306362,1041238,492697,936224,691961,302103,1005130,13846,98704,412477,331154,878887,980450,928134,56649,609710,397442,713906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504633 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504633 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]