SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439853 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439853 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222618,226589,703604,969615,103451,396922,701875,65715,235305,496130,768164,437287,957659,1031151,807467,946367,765844,760215,341756,728791,705791,540681,753780,653658,538345,864819,967522,230396,578522,785548,993985,692800,247055,877910,687699,433462,450076,253187,105411,570776,844407,550505,117147,249231,660779,781554,526115,2199,673873,422111,1010638,670898,1027891,334229,702320,903261,929605,383294,699398,841945) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]