SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407972 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407972 [ RunTime:0.004575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405011,733367,880471,511920,258201,760629,1045788,224960,381643,354474,143728,358701,696032,707510,1019912,962537,408324,770353,167924,652115,101568,971877,520777,492999,129435,515939,111841,370714,277570,47142,374900,418804,258232,599696,217860,181113,842851,12540,36802,706608,364003,621024,15170,100452,461532,996654,318908,153017,515080,945038,587282,276856,642456,894376,767573,563313,730045,272905,606461,696190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407972 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407972 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000764s ]