SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037899 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037899 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507523,17476,606756,206462,700124,361882,820376,829482,1013363,220553,933301,319964,702136,526747,380614,900666,166762,709540,425471,546069,147106,578805,308692,775879,624162,347896,336137,602813,621055,313239,223534,607072,640122,736021,76237,616553,933661,418205,100286,531410,24582,371497,353157,603389,343443,610621,560477,821029,824701,487333,140111,274634,326054,360426,47345,649534,984657,272653,684061,346027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037899 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037899 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]