SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419250 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419250 [ RunTime:0.001942s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805026,777310,537331,606041,446334,630585,508763,611880,747398,222108,469868,893735,660476,233958,532178,901262,837843,1043696,403166,311598,521611,245926,112257,181563,172981,979203,653779,1043216,492939,653230,411610,435426,1046178,59,963575,615802,186546,758802,909721,832527,85632,758923,533609,311158,231044,336147,202159,724114,398385,795056,213613,349382,919008,348707,661058,718528,33947,251443,133014,257118) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419250 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419250 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]