SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106563 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106563 [ RunTime:0.003115s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180440,430505,17476,276922,711592,621779,351540,573535,148085,1012850,1008358,748031,707870,20955,562339,642897,790446,785808,253390,1046689,798484,46060,1014774,752747,775510,619158,894034,980626,387194,718711,359085,1023005,708895,580119,266558,401069,887915,675177,301143,981553,906153,812697,839028,234822,413653,349054,241226,859702,889747,711180,682930,222881,254614,713328,910409,1005825,549544,561911,334497,178467) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001618s ]