SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 919789 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 919789 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417281,214535,53069,359515,1005556,1039092,1022153,685133,472611,159216,797178,282497,615019,457188,994450,512221,783836,104699,342547,2416,698115,778313,126043,43823,268977,869168,980420,60746,185292,798389,92639,109225,235149,1024164,967013,557598,580894,1039938,159169,187588,295183,535735,395450,801776,35768,932589,170986,25085,791600,53994,907633,79540,407160,702662,35208,215910,87033,185812,1017148,767113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 919789 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 919789 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]