SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341039 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341039 [ RunTime:0.002062s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (786491,520028,678628,590084,997544,778751,969569,525231,39657,392976,820816,352408,229461,651022,453373,913205,863261,569360,907176,385865,412841,522209,102358,212853,537417,491570,293187,79807,162827,99342,560815,683517,586806,755697,836999,20645,672433,365545,740326,910334,162803,279707,460286,357731,836219,743856,44986,548734,88545,81932,696348,44335,645501,88217,743431,104468,445400,740063,929648,26311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]