SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409038 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409038 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (357324,1035372,742033,217465,959911,433518,244744,261769,407123,418152,633524,892234,388144,33821,779498,989281,128833,803493,564403,66124,273268,955605,270883,428998,609954,505915,194622,158671,331708,287630,614844,820202,340924,796072,315962,380061,375044,54741,911575,767094,532803,448553,710560,729476,416649,340620,253911,810477,499560,783754,996561,749737,616288,675513,803172,69521,23376,692820,989600,693567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]