SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 170180 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 170180 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015331,331821,917890,884994,747844,996704,254858,748391,564410,583553,881273,983423,97201,876537,816538,316101,114179,322741,373559,357461,36713,1039059,558980,921622,699030,431612,245143,536893,239745,748258,416072,506512,629230,257786,488291,942086,533141,168686,797500,449747,955469,836151,624088,179019,485089,409675,592037,911325,832702,570900,692199,890562,601211,101536,322613,1008544,1008235,622336,90998,548638) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 170180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 170180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]