SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526047 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526047 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257463,387032,613173,13687,601815,816306,39924,787843,601944,701040,194156,839469,267709,397264,673471,613622,55321,600473,1017017,204457,899901,668016,767391,538661,244898,955945,501559,663652,857768,731938,121419,438283,929037,257171,727340,642854,766690,472178,927225,811438,336253,198965,703030,379001,333550,410653,219521,505509,282735,861339,1029191,272073,309235,971741,201184,128557,897702,171951,87326,292372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]