SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426968 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426968 [ RunTime:0.002685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316387,914604,296758,81639,292289,652861,241512,60660,223263,592444,144848,342014,643153,157437,211699,1040582,671160,134442,59865,1028703,363020,955062,521693,1038275,395996,206490,26490,198670,424307,151205,531877,751450,286924,293549,146025,153733,621496,547938,66741,83389,594648,954017,339802,808322,263901,139167,726306,577577,21813,553726,993594,306437,445428,475294,608540,753826,494281,376307,313145,998687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]