SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467322 LIMIT 1 [ RunTime:0.000631s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467322 [ RunTime:0.001508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516264,148093,842890,52062,443503,929655,199447,773105,354272,602218,460529,517404,954894,718055,954250,45309,214815,210644,874199,179380,223101,753049,876169,513736,25660,390356,716954,860110,8151,229865,1018323,125591,37845,275166,216200,816538,158406,93938,902507,309362,772966,629926,98112,26306,951548,796189,83241,638881,468006,176900,380129,1002637,54709,923871,989885,819043,909948,862044,154383,104395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010798s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467322 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467322 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001708s ]