SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493001 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493001 [ RunTime:0.001445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (237322,899659,690961,218009,756744,743442,461336,1044948,850405,326443,95087,177826,803348,211435,458364,1002797,77461,408206,18400,259678,163940,287251,504427,218909,930372,916367,312630,898255,180557,455602,170306,705477,951220,966217,698091,494488,694061,233075,505141,957456,581837,597900,416596,722969,163319,345762,394140,286571,78900,499651,916365,700462,663947,348421,581298,23529,397271,89432,584691,544551) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]