SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423672 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423672 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (243931,928781,111028,1041821,428756,138733,697880,312926,128253,41749,539182,1009625,574856,580504,907783,344923,794414,23594,554092,208562,537305,1044217,1031368,739001,160247,989998,169711,631215,257918,106545,277972,926248,38173,351961,427208,881437,742758,221343,343254,76450,933268,642487,178096,814203,734124,57203,825639,433826,231058,27249,107871,273410,436834,581684,380217,221980,318247,207822,1011121,455029) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001658s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423672 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000629s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423672 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]