SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535043 LIMIT 1 [ RunTime:0.000786s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535043 [ RunTime:0.002923s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411329,105158,324217,472144,918552,779507,678543,999555,798330,382052,696338,735562,143489,234695,617363,473311,260701,207516,850972,390342,598799,425955,396811,69768,547884,894740,419707,636926,166097,271292,330500,1015084,486848,915633,113950,231629,827530,563225,55493,396040,647304,257508,530289,495776,207698,423705,163215,433940,371910,511488,565406,57437,80629,785996,536023,245227,743047,128624,821923,970315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002754s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000823s ]