SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424481 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424481 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041703,599406,328551,339714,308321,839004,642871,686363,37795,607417,200172,367445,435510,981793,518828,306505,651972,681621,356546,929394,120685,368605,784843,417311,685212,283084,29197,465442,1024294,856568,456604,714862,155603,630974,345638,606944,715090,457049,559999,853082,397379,266092,850851,880430,947150,448811,231725,111624,845384,625395,751968,390734,637950,584110,957993,834223,959122,82619,823873,803858) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]