SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010501 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010501 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546723,508628,709795,93525,498098,458577,743517,535440,539890,47447,674078,103709,576183,875089,767616,404806,979788,374695,441495,493481,821847,38248,1016023,725800,366291,406113,782082,628111,65800,995127,683146,462285,715329,179145,273491,668724,307822,921378,612960,89870,405134,918939,338642,360132,904417,743504,55488,187302,1025510,976010,1023641,49995,737492,618775,704234,879271,942730,790294,9621,423400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]