SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471901 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471901 [ RunTime:0.001515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902230,1032868,136109,907032,976239,545733,835971,201771,1017482,1037725,752631,697387,82522,616983,1015805,106043,366996,52704,764667,299266,624846,1009102,243217,307497,478794,825337,923574,546695,501590,43895,483157,1046460,268375,415867,771607,973938,942767,739564,173847,871738,813164,1043628,861612,762135,136905,39630,158414,761503,262165,331384,967135,952771,317272,688350,451732,545581,3496,916939,750402,105362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]