SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 690582 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 690582 [ RunTime:0.001571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (147384,4799,622696,196827,534911,386254,191347,206222,155233,71885,918390,1027878,689371,528944,464289,548496,196543,89220,1026743,533689,25172,481834,210568,888483,199484,876066,190100,18609,774443,857682,425925,370280,380920,120114,837704,141083,968200,1017331,767539,72900,302091,155925,914800,332534,649316,668647,1024817,887156,288801,763859,932375,700158,1034382,493424,407736,278764,350015,248974,202755,78503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 690582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 690582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]