SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046628 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046628 [ RunTime:0.003249s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63350,259387,54181,361420,997643,530062,76712,140837,244799,497960,571982,30068,50610,1046192,361782,923715,128227,219389,307927,100305,695511,44336,233437,286441,59370,996448,723057,777679,951509,772449,697658,571715,44497,145107,310885,378849,649381,866146,999453,890337,523470,1003554,507875,249583,551082,57459,987405,740572,84542,657380,99978,95051,376524,472956,975401,805125,686336,658944,839063,59418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]