SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400545 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400545 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045792,937086,368834,379926,886616,175173,663280,803220,383417,273794,386216,123412,742488,447762,761080,317888,73903,92343,682374,252133,753220,820984,572203,415499,285754,541837,680159,353965,700048,540339,990265,879560,1011681,585736,481670,811116,175078,990314,273774,684089,242817,387978,939979,447909,154155,779959,701075,251994,16660,170272,295978,404611,6811,444213,541824,25218,791544,133437,659052,124106) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]