SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503525 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503525 [ RunTime:0.001691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (711328,840887,412533,943406,36043,306400,966897,946840,794070,582019,222282,687111,834527,608026,927805,412502,418695,1488,870342,539326,116403,283193,725178,725667,812669,703449,468899,302284,880384,716968,768194,306792,627991,174540,351402,555044,905192,337259,949445,32783,1001942,111529,439482,312391,384145,889445,253215,269574,676107,496456,377207,321158,138173,156402,57086,111061,154317,80824,521773,857986) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503525 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503525 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]