SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 395183 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395183 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (921148,296064,378677,37431,898715,125166,867754,769361,381149,262918,907564,469824,1035494,174970,212337,454909,446466,786867,502637,370798,905712,105397,141707,1020303,255108,800286,1005410,226662,971142,7624,87950,342992,1039276,218112,430284,483745,679579,869041,850420,905621,145347,370769,637209,901684,571312,837561,652502,707735,1022360,362140,636946,284753,518494,699615,215418,702981,919159,36302,118021,31270) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001856s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]