SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005007s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283842 LIMIT 1 [ RunTime:0.001439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283842 [ RunTime:0.005286s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518981,831027,407340,13278,502410,1023359,457243,668017,949268,898627,1003400,537689,532275,377032,807568,1040189,218771,989542,972313,838275,518065,302731,593176,895441,237432,132960,291607,403767,567536,495144,746456,770735,251634,28574,834852,528002,197590,658102,817187,363583,335928,537563,641389,423821,829386,455456,372464,409455,462830,698765,1002841,1014706,622691,105253,151074,874525,113212,279227,194897,172726) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011658s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]