SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101399 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101399 [ RunTime:0.001963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44817,197247,908303,254695,908487,474514,643676,531859,777412,473661,611641,244054,637204,75363,479,697517,6126,190629,635114,769177,5023,361329,197690,43937,2255,148102,913760,251940,700645,18164,93315,995752,721088,812455,536566,252235,550974,210714,479776,511687,714076,876214,356933,991832,852951,901414,687004,410921,341210,1032587,878887,74693,527867,464782,374226,108325,70707,314524,209717,651144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]