SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507811 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507811 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (718399,392338,663432,267718,382441,249238,624019,101300,1013130,480852,38678,1020963,30665,367568,338083,361381,226466,978276,141930,186372,94978,356689,191821,98486,493037,69408,258971,286648,203926,207654,624964,60789,411723,321,452969,497819,327746,415947,781337,196134,627019,366352,650286,828823,427251,586232,489773,574558,955800,523240,173603,819009,453691,214331,187626,499886,1018256,658537,621751,554228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002718s ]