SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 820197 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 820197 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (477583,300302,458660,505990,1048761,238312,343956,202216,745840,510140,879383,316605,713774,285119,243422,495942,854977,284721,645203,511011,220606,752949,502284,358921,927052,135033,402862,249624,262059,132420,252749,406922,153126,531400,334858,217995,556320,757462,997914,498397,49012,1005880,285750,975200,492888,838788,73421,874679,685039,5945,250392,613653,178756,116799,1017717,587135,922793,479781,151213,122899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 820197 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 820197 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]