SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409601 LIMIT 1 [ RunTime:0.000564s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409601 [ RunTime:0.002162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391861,832927,581728,480420,396734,481569,795196,70803,682320,790360,716211,789129,384290,34915,964071,846925,655816,288619,289416,717977,622001,849837,207106,738796,216317,101790,393270,592638,530688,736766,1044856,68506,820360,807233,447280,225601,975539,89487,288084,93898,1044180,303470,497968,431893,729659,921646,449082,545878,549638,352744,20939,393468,343535,317910,779845,241929,130173,1026812,785011,788033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]