SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555618 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555618 [ RunTime:0.001976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035700,296469,677484,622685,644071,665651,766995,237807,26238,461574,880972,850341,994013,847102,808742,529594,1010587,462063,738637,58776,399653,145229,769582,716836,429649,66924,73173,517920,709074,27664,731589,931980,214210,764610,630422,973090,44365,453120,731800,587772,727451,1027809,256768,588907,680323,1005256,941944,212987,336551,880839,819220,343940,902307,1032387,187898,684888,156875,385689,335746,721712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]