SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511628 LIMIT 1 [ RunTime:0.000498s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511628 [ RunTime:0.001993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122566,569175,1009790,758742,642733,999313,268793,459217,696335,1033250,430592,656177,917539,672288,963506,88724,693038,736125,470080,310280,863683,20341,919297,59044,485446,541778,243134,226087,175394,495693,887490,217068,640361,889243,300071,473857,237508,949632,569064,364290,382659,588554,943081,810794,227321,199422,639164,795291,275118,11249,61052,779490,668936,516017,753859,121543,600794,721956,819963,500840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001078s ]