SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534053 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534053 [ RunTime:0.002303s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496028,417278,870615,1005372,624225,753271,382478,731921,705651,1045341,599194,295145,1003397,426052,425547,844183,987146,692820,220491,733492,131412,17236,803004,877755,880997,476938,31908,56274,649098,57732,282667,355480,1047343,580163,124415,514046,688259,700068,755759,694667,439903,44356,938348,614611,633013,495049,42800,994113,199398,609526,863661,323652,769323,396745,49070,470649,567840,1023629,893990,749505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]