SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498113 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498113 [ RunTime:0.001441s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318274,447581,16939,720756,642162,1016669,495058,701901,744524,72979,618034,404899,77028,964216,344240,1016767,614617,789391,962087,365229,211346,404335,289242,48024,727154,936739,439637,912306,280800,164495,298420,96844,328363,904669,261328,440163,1028025,417403,813819,459292,578724,39915,263937,752998,151700,233449,340756,932015,216288,885569,506913,424942,978430,148750,792947,504855,469944,678235,118838,654242) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]