SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001480s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564753 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564753 [ RunTime:0.002268s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (461478,808227,109623,733145,815533,984334,655283,495095,780656,370597,356821,729969,825880,854429,563178,387675,310573,979764,64591,645367,813183,208539,661126,750949,80777,18589,477951,1019502,928465,552826,625325,645838,801231,60982,884191,790619,573154,420071,410855,1042605,722437,200336,996878,758734,838274,715251,15017,505622,69313,704391,249349,950328,243836,180295,587352,560673,891301,147254,603504,638910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000721s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]