SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544825 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544825 [ RunTime:0.002467s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812708,20815,283507,86977,393390,576242,429034,871143,17536,915218,993294,415382,104000,583566,801064,567087,801461,376214,294279,11766,643735,881946,590475,205598,262565,1030154,633045,163869,659923,1009765,281512,693890,310405,352775,509454,735981,401758,891884,111206,332170,719530,1028305,64575,562624,614983,867382,396034,761698,785903,1027709,911035,451101,935189,55125,621573,217190,543735,991601,350409,116627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544825 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544825 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]