SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019861 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019861 [ RunTime:0.001851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (211697,157588,851595,347420,581622,438678,249845,1005534,673744,582092,677305,3155,815590,400151,124451,169364,792624,235702,630821,1034167,104009,761387,178883,596892,199568,110417,450468,828436,847506,737404,38930,854717,412050,259801,696969,938009,474598,291867,947824,309494,770878,625560,611670,899799,21545,1025247,85707,1018989,526976,910305,662102,848146,6068,705939,330614,340287,704017,510907,226518,704669) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]