SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196062 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196062 [ RunTime:0.002785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014774,112205,900677,841570,532495,629004,224188,659628,196200,466999,94707,1046912,310319,323713,150105,251567,1042110,821992,349675,882242,500206,417398,234502,684232,441151,798668,886513,107780,313028,637706,287440,296728,423043,821651,472653,613777,571380,168289,234519,693876,362061,815202,1048774,779976,1023484,742597,81211,934555,476423,1047571,481992,827627,465754,491310,364051,581743,227496,468684,676498,245780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196062 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000797s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196062 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]