SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194412 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194412 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (680400,357744,896682,404523,952676,873200,362643,381779,848530,979766,601506,343722,936815,275316,838462,897521,359989,485025,787157,724447,268402,363488,440064,504954,488044,1013978,400027,982868,269532,681498,507242,400926,64543,573658,123385,205018,996867,894482,72168,490735,807806,787564,175530,274076,521023,486215,387900,654632,358071,1023736,224999,430884,394094,479618,431532,994781,550792,183204,735723,859656) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]