SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001639s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427041 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427041 [ RunTime:0.002620s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246385,93454,768734,26895,256755,104282,22657,282904,308503,719800,96637,794820,661993,1011721,608204,273837,244092,902285,874715,948388,5716,880344,255425,823392,272465,635561,867548,3791,960399,898407,1048411,1005360,667229,947730,754626,327448,650537,1026081,1010941,555258,585209,10825,433465,148388,604450,580322,334294,486369,434115,698340,926045,494029,320850,1032983,983299,656668,380168,3042,419879,233821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]