SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427450 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427450 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017233,179027,969920,450917,694159,526624,968112,619253,778407,276752,759340,970490,63568,437182,197860,725091,688465,515801,898976,338701,982311,30535,313086,25428,49112,404239,557829,465282,811382,29397,388244,824237,100075,148074,40882,290828,571226,589565,609925,85558,917155,1047624,853360,898490,868314,683288,489293,268584,582750,470639,629973,822104,197046,568571,620341,357650,387680,435858,96767,952361) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]