SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543403 LIMIT 1 [ RunTime:0.000510s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543403 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (325673,576484,317613,602144,54984,4501,1016360,28461,206133,434125,247500,24730,324005,386683,197866,605476,631632,626995,176060,1016482,709621,775658,950360,733418,1048529,958268,853779,335486,250274,688068,709132,839551,839756,105981,112714,187638,788065,881056,719006,546675,304167,548987,433033,361733,741109,794946,106580,699162,293927,965302,946249,599665,959936,536382,951950,768531,285028,517151,510591,140992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]