SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500628 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500628 [ RunTime:0.003908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (627306,414109,879105,406704,941208,919904,619021,684309,664261,569400,209477,842901,80936,694092,910512,864589,207043,676873,580960,105365,615528,761810,201975,136940,786752,621489,805503,105424,697743,142608,381885,214457,625363,916979,310394,150836,682501,58666,562532,146833,167048,599335,380760,781120,300453,680588,250486,216176,838067,627034,56816,41385,214081,488640,518168,655466,594232,615952,294871,86687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]