SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280439,1014520,987841,762517,593225,111692,156259,214463,278819,907644,702939,1286,275821,805004,630155,306876,235750,1014734,18821,596916,281438,750306,350770,226881,701393,694457,731523,938598,884571,180821,713485,634506,39886,280167,801968,864592,948371,293246,300028,490976,954193,54450,826758,32682,533071,396704,68594,894916,37888,672677,997292,331421,947890,149950,868152,1002842,536040,878480,997475,862032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000389s ]