SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283203 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283203 [ RunTime:0.001814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (218463,167123,921168,217496,1039495,7101,404468,771992,656787,818817,498277,919070,895735,552931,717689,281723,915148,221574,218494,804533,610854,738941,414116,662842,141679,827997,206809,610555,865176,506087,628965,524030,745918,105092,557698,72437,468060,160402,822670,273510,354247,256003,136081,451168,262781,187442,121710,1043259,605530,715030,937258,459584,345719,837675,603698,178862,742463,1027251,140027,862138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]