SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 97401 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 97401 [ RunTime:0.003381s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405534,178094,816932,736995,337659,316836,765428,823256,66423,539656,41250,618531,266499,127593,1041575,318072,697266,353650,505895,326073,230581,832594,476109,284255,1035633,249653,311813,851308,662313,536244,744394,367996,697553,71492,47689,264316,474541,110747,79136,259223,984724,654330,472113,592981,800380,683206,1026288,887386,858781,5800,918533,165064,185078,790665,262153,184318,997935,60407,1448,958994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 97401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 97401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]