SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110571 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110571 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (372672,162733,613490,30191,953645,201011,168981,24524,793922,994886,313031,384286,986968,803382,207683,610564,1027400,27612,339118,5880,573302,93187,59071,340728,131523,101260,230003,491923,110464,250112,427400,1019642,918343,695624,464129,574792,256799,287713,260603,701505,350219,574600,868495,514578,443936,238835,438939,583712,128044,520369,219973,437746,448104,601811,810581,847495,959043,830389,487116,896211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]