SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506371 LIMIT 1 [ RunTime:0.000530s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506371 [ RunTime:0.002140s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430366,77184,622107,557961,584753,541367,655848,525702,87143,864608,170050,801585,555727,826519,668406,771997,134706,304744,153241,912471,832454,750874,49406,687121,701800,960457,201824,471635,778249,337111,227229,245877,167728,550454,930679,438247,98308,726720,900574,241062,221622,486607,565808,637822,287900,103399,67462,22872,767990,961282,82898,633324,321600,296700,617364,692396,843173,386693,630960,972729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506371 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506371 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]