SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539613 LIMIT 1 [ RunTime:0.000519s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539613 [ RunTime:0.002669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505034,464522,1000652,2534,930398,7911,996691,119896,229892,381068,169850,250018,970638,6605,340113,281954,855800,385547,703066,258340,923709,620821,537670,785209,318861,264103,466142,243977,190164,1005999,339168,500130,895016,679731,665735,231629,725640,761079,238245,75016,776527,995100,71674,121311,611991,1022230,321678,1000037,975695,430904,828366,731433,981291,323716,517452,777436,199294,369672,998345,816581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001414s ]