SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004594s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 174500 LIMIT 1 [ RunTime:0.000498s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 174500 [ RunTime:0.006848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (818016,1008364,415586,705286,298174,346180,1040132,772907,497833,846393,245536,175120,445471,726523,79586,508189,122390,801176,201539,420027,203523,199565,713439,764439,38067,776610,1016213,114098,398330,606237,675442,672824,429168,13296,852692,759687,638418,413829,151986,795261,930405,378546,685660,334481,205783,953513,718950,509396,734749,916737,914039,776435,822046,863708,171748,291132,702457,78985,378781,726238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 174500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 174500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]