SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537493 LIMIT 1 [ RunTime:0.000678s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537493 [ RunTime:0.001965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245321,595917,722304,317153,282398,989148,716503,863316,983377,353819,432600,454000,833767,224542,608879,142983,1013509,43662,115020,487850,77643,480699,346845,20367,646908,137614,340277,453580,588087,342788,865382,887976,735614,216858,840442,603107,925458,541751,150634,479451,345685,14314,828908,340793,118843,349634,50169,685147,629101,167346,8243,1004927,482609,125060,561624,770938,1006660,748377,98593,294341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000763s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]