SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 387910 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 387910 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (13716,547001,407033,320115,911154,193741,337002,996762,848195,142045,457631,517776,1014096,384899,803560,600422,858270,430717,485587,253403,708872,442934,166814,604757,515490,720227,885923,946197,618912,69562,606847,78095,335563,405501,762756,142661,746252,825694,906119,325758,1035483,1016026,606695,46275,120156,161812,954376,614592,941978,311638,707105,374800,1013128,479651,540345,660576,180159,165897,210093,495741) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 387910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 387910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]