SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434940 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434940 [ RunTime:0.002148s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (742143,272153,108678,681022,923476,323981,98993,464138,26831,489915,758722,237909,127268,188906,394607,293380,49705,459396,666905,586637,866918,155256,26634,871163,721046,1011238,322825,359896,1026205,280380,381533,261992,220663,803011,392909,449474,122897,775715,424091,821981,711516,860749,265782,28137,581985,663310,651467,498956,868306,373321,94556,272847,425295,403353,765537,859030,1015252,444490,874155,238961) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]