SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517283 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517283 [ RunTime:0.003718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (87274,486767,206233,82679,659811,237605,311455,218573,333010,900893,322036,223537,338048,71876,246672,663507,804508,617357,152564,193292,41541,998858,742592,603507,470433,186553,387939,230897,526594,954887,945820,584530,123176,245882,239486,569665,305167,681824,117750,238572,797084,894590,418072,209283,12582,35458,814435,344318,1027107,738475,990490,45710,504187,697771,221092,836614,737183,534248,788013,566176) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]