SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541482 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541482 [ RunTime:0.002551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417865,534258,1024449,61764,8182,965196,860556,97816,492184,786719,270061,970112,966002,796621,1040887,34349,748447,895825,73204,75053,473007,207854,700871,39104,150492,1020732,933266,182184,195419,1042972,1005656,394806,476406,680083,257621,790893,319517,447079,286573,53373,620679,818196,503833,746061,291107,871890,48156,997638,959706,543395,451981,575135,758041,897158,861394,816770,470949,646126,665047,405438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]