SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014380 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014380 [ RunTime:0.001548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042647,424363,15843,684175,927086,416445,92195,816389,821333,959632,932193,789717,708562,157953,425368,151287,189300,424111,345001,842814,801708,1039423,287123,461901,318624,674838,277323,904003,989033,406916,255039,351345,191862,389827,888557,768104,932381,938354,966530,629225,638576,361547,173536,851529,614123,393336,581253,605809,985837,650720,778364,636823,772390,227647,347317,1029267,539746,968860,444311,109663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]