SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002404s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480084 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480084 [ RunTime:0.004187s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654439,718471,784272,603557,651753,104250,630081,659379,254188,922512,461518,160898,266495,639012,819049,361898,711738,780189,471775,413430,505587,641141,278669,403727,323036,576691,838318,1029880,18854,823066,130526,815562,979825,572196,760958,162321,1007971,442486,564127,522171,751272,661890,605953,96838,565808,1026728,1015162,547693,253694,905372,404351,608349,640927,44546,983657,166794,103466,889323,314301,83008) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]