SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412180 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412180 [ RunTime:0.002028s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710030,289791,883815,705825,880331,560831,633785,788548,571410,323184,622837,115630,809075,35001,665186,473297,663293,261362,867953,830711,1003973,832318,203650,480248,78312,478817,391163,1006286,574588,1481,685558,858201,229907,90809,588663,87639,715282,20356,601476,637046,311981,628562,660226,161034,350420,654215,425816,939099,611620,506349,175561,33305,266253,887884,111870,204903,366504,822709,645373,774460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013899s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001921s ]