SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404293 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404293 [ RunTime:0.001856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29658,329997,385651,647704,491511,375523,737341,313815,260492,825810,884152,699286,315516,804347,352575,752603,565256,693234,937680,171830,865157,479448,1029723,1010764,643717,1015436,679643,784735,365405,279088,700629,80356,393822,16694,13224,214715,679300,278798,934163,815259,649889,820917,568658,411151,777176,671986,170977,691634,1015473,874601,814326,262214,901261,56845,345809,691119,1046693,736058,753325,725107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]