SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407764 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407764 [ RunTime:0.002876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40844,152811,986219,327185,454523,238361,906827,431106,534623,155745,137458,678687,734823,959271,927965,453981,202063,831506,49819,745525,812801,49922,285357,644170,215564,737216,593929,540910,330429,746514,708764,262671,400757,117544,268878,237144,533932,9228,473332,528663,578208,483251,1037578,622283,759545,391245,827886,902851,955659,887985,777983,621116,732428,85094,378605,201150,576308,882311,903379,716415) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407764 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407764 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]