SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002774s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028100 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028100 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433278,173311,544827,268529,184222,930005,958477,442976,133417,799577,83198,549544,27491,260258,722985,881702,941778,257164,84261,798570,722691,459862,43164,447550,564577,284533,898655,380914,226441,1011377,476966,827008,1034765,238517,855499,508243,318908,552205,481177,962886,850456,741899,47202,462313,180635,873381,607989,62543,738324,839766,190233,524110,534571,840144,221885,341449,235177,438696,164495,400531) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000406s ]