SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982740 LIMIT 1 [ RunTime:0.002560s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982740 [ RunTime:0.001846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (804413,638757,879662,98942,768454,335148,588076,387651,1026805,1035867,426791,332511,280074,629653,935460,272559,1026382,396297,1022015,871195,381470,660690,63307,504382,466484,408642,568804,156916,1038533,551538,817339,470334,1047571,415963,669325,633290,810058,979831,230292,369310,502554,477882,529178,377587,575958,10646,499727,131705,510165,647607,501456,58605,722851,31309,1036894,307447,29736,512958,91590,721739) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]