SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515213 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515213 [ RunTime:0.008056s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543492,449956,573142,333893,891166,728230,201161,35757,25501,194123,488085,936510,619196,428041,1014413,378177,189885,954367,725535,659771,482416,958657,1029332,122911,530094,791404,983600,464214,295049,657445,975830,748479,1017329,808721,954088,181572,573202,807973,863449,380854,410895,816478,31444,836973,1013439,892579,332894,198162,241276,811970,802299,843687,505367,992180,388459,282031,739836,750207,600328,406010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001491s ]