SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523913 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523913 [ RunTime:0.001910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (601223,46093,26386,512036,18565,440688,985116,818567,751517,226446,583591,106362,528165,606779,329338,210336,350558,932968,65454,542229,539237,69930,143247,996006,281689,586071,248948,43710,405169,861530,396879,735646,619845,257355,291259,847695,520661,455262,131779,686507,962832,769359,484821,583578,972248,113792,160038,140069,596214,416948,299353,46485,8457,537466,92912,397797,375677,71516,72981,101059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000901s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]