SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001647s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046118 LIMIT 1 [ RunTime:0.000911s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046118 [ RunTime:0.005210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194878,650971,233790,768455,45070,150655,512456,577095,796381,208682,658104,649081,590241,530678,326567,43221,544711,119688,106672,573617,187949,912093,611348,1030387,926091,869576,837852,39868,167351,811487,1019566,946118,872994,328809,443499,674413,18306,682444,41761,127188,385778,50110,931500,969404,840853,42078,671134,802997,880717,999444,767566,824653,1022752,581809,329651,44791,342621,128187,758359,973687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]