SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003365s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435416 LIMIT 1 [ RunTime:0.001400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435416 [ RunTime:0.001998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40237,390870,408585,507597,418436,110789,892951,485754,245374,346692,431366,332326,971637,257461,442006,657289,611445,130081,359731,400696,15128,381385,260323,950206,304580,36679,534341,593729,107877,636537,537361,222656,613261,410861,676035,778399,1038262,386988,559984,634792,60714,980275,603309,812225,593510,756573,858578,847642,470449,271517,6336,799433,181571,982743,299247,236161,754335,532908,590776,926484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]