SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 683099 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 683099 [ RunTime:0.001982s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310451,77052,851501,812843,727152,60489,305703,665,1040950,102997,128517,549536,418097,225953,438594,993941,795114,476886,467986,727435,901476,176071,82147,431938,302562,462112,957669,528024,808915,185266,460876,28880,773028,115913,944939,70578,93459,816198,822678,184499,755371,970351,45186,63896,652078,532235,346572,258913,52900,375842,728280,802179,436455,252758,1005300,1559,22514,344370,475727,374074) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 683099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 683099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]