SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 72450 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 72450 [ RunTime:0.002570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580450,958019,865161,574766,200246,181139,945997,614248,13533,226070,958474,61042,748757,292368,394424,135220,276433,752552,472671,428489,850177,507505,648140,418512,434000,148457,229923,747332,854209,31936,43893,625084,171123,137453,168267,554110,295452,198511,929654,828125,317771,264203,1012151,279678,659645,1018784,318557,861024,895520,959524,1005750,668648,690345,754765,641675,121908,943454,202177,924025,706953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007646s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 72450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000669s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 72450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001118s ]