SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 374451 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 374451 [ RunTime:0.001699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382198,322116,591025,1031562,185394,614178,348160,899074,998772,376444,67577,433409,874636,418988,45394,157136,323250,149977,35925,833159,1041802,514025,1027531,980217,519062,518230,942337,908817,852740,39547,163038,1048664,524695,483609,105023,181483,554124,140066,851330,481341,898117,993181,883149,70680,259845,798124,194815,427002,344162,287365,884598,305031,242935,998837,977151,574508,163398,690283,569027,819925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000923s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 374451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 374451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]